-- SQL Loader Control and Data File created by TOAD
-- Variable length, terminated enclosed data formatting
-- 
-- The format for executing this file with SQL Loader is:
-- SQLLDR control=<filename> Be sure to substitute your
-- version of SQL LOADER and the filename for this file.
LOAD DATA
INFILE *
BADFILE './tmatch.BAD'
DISCARDFILE './tmatch.DSC'
APPEND INTO TABLE TOTE.TMATCH
Fields terminated by ";" Optionally enclosed by '"'
(
  MATCHID NULLIF (MATCHID="NULL"),
  MATCHDATE DATE "DD/MM/YYYY HH24:MI",
  venue,
  TEAMID1 NULLIF (TEAMID1="NULL"),
  TEAMID2 NULLIF (TEAMID2="NULL"),
  tourid,
  NOTE,
  matchurl,
  STATUS_ NULLIF (STATUS_="NULL")
)
BEGINDATA
17;16/06/2012 21:45;v;4;1;3;n;http://ru.uefa.com/uefaeuro/season=2012/matches/round=15172/match=2003336/index.html;210
18;16/06/2012 21:45;v;2;3;3;n;http://ru.uefa.com/uefaeuro/season=2012/matches/round=15172/match=2003335/index.html;210
19;17/06/2012 21:45;v;8;5;3;n;http://ru.uefa.com/uefaeuro/season=2012/matches/round=15172/match=2003337/index.html;210
20;17/06/2012 21:45;v;6;7;3;n;http://ru.uefa.com/uefaeuro/season=2012/matches/round=15172/match=2003338/index.html;210
21;18/06/2012 21:45;v;12;9;3;n;http://ru.uefa.com/uefaeuro/season=2012/matches/round=15172/match=2003339/index.html;210
22;18/06/2012 21:45;v;10;11;3;n;http://ru.uefa.com/uefaeuro/season=2012/matches/round=15172/match=2003340/index.html;210
23;19/06/2012 21:45;v;16;13;3;n;http://ru.uefa.com/uefaeuro/season=2012/matches/round=15172/match=2003342/index.html;210
24;19/06/2012 21:45;v;14;15;3;n;http://ru.uefa.com/uefaeuro/season=2012/matches/round=15172/match=2003341/index.html;210
